package com.ys.web.del.mapper;

import com.ys.base.BaseDao;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Param;

/**
 * @Author: dhf
 * @ClassName: DelMapper
 * @Date: 2023/2/10 20:33
 * @Description:
 * @Version: 1.0
 */
public interface DelMapper extends BaseDao {

    @Delete("delete FROM `busi_red_record_cash` WHERE raw_add_time<#{day}")
    int delRed(@Param("day")String day);

    @Delete("delete FROM `busi_red_deal_record_cash` WHERE raw_add_time<#{day}")
    int delRedFlow(@Param("day")String day);

    @Delete("delete FROM `busi_transfer_record_cash` WHERE raw_add_time<#{day}")
    int delTransferFlow(@Param("day")String day);

    @Delete("delete FROM `user_account_flow` WHERE raw_add_time<#{day}")
    int delAccountFlow(@Param("day")String day);

    @Delete("delete FROM `pay_order` WHERE raw_add_time<#{day}")
    int delOrder(@Param("day")String day);

    @Delete("delete FROM `t_goods_order` WHERE create_time<#{day}")
    int delGoodsOrder(@Param("day")String day);

    @Delete("delete FROM `withdraw_record` WHERE raw_add_time<#{day}")
    int delWithholdingJob(String day);
}
